package com.aaa.maintain.dao;

import com.aaa.entity.MainRecord;
import com.aaa.entity.OperLog;
import com.aaa.vo.Result;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.cloud.openfeign.FeignClient;
import org.springframework.web.bind.annotation.PostMapping;

import java.util.List;

/**
 * @author 荆豪峰
 * @version 1.0
 * #Date: 2023/3/2 20:00
 */

public interface SiteOperLogDao extends BaseMapper<OperLog> {
    @Select("SELECT count(oper_time) AS cone,oper_time,business_type FROM sys_oper_log   WHERE business_type =1  GROUP BY oper_time")
    List<OperLog> selectAdd();
    @Select("SELECT count(oper_time) AS ctwo,oper_time,business_type FROM sys_oper_log   WHERE business_type =3  GROUP BY oper_time")
    List<OperLog> selectDelete();
    @Select("SELECT count(oper_time) AS cthree,oper_time,business_type FROM sys_oper_log   WHERE business_type =2  GROUP BY oper_time")
    List<OperLog> selectInsert();
}
